Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'External Document No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to EXTERNAL DOCUMENT NO.

Seq No	Page Number	Page Name	Control Name
1	20	General Ledger Entries	External Document No.
2	25	Customer Ledger Entries	External Document No.
3	29	Vendor Ledger Entries	External Document No.
4	39	General Journal	External Document No.
5	40	Item Journal	External Document No.
6	41	Sales Quote	External Document No.
7	42	Sales Order	External Document No.
8	43	Sales Invoice	External Document No.
9	44	Sales Credit Memo	External Document No.
10	45	Sales List	External Document No.
11	61	Applied Customer Entries	External Document No.
12	62	Applied Vendor Entries	External Document No.
13	88	Job Card	External Document No.
14	126	Cust. Ledg. Entries Preview	External Document No.
15	128	Vend. Ledg. Entries Preview	External Document No.
16	130	Posted Sales Shipment	External Document No.
17	132	Posted Sales Invoice	External Document No.
18	134	Posted Sales Credit Memo	External Document No.
19	142	Posted Sales Shipments	External Document No.
20	143	Posted Sales Invoices	External Document No.
21	188	Posted Docs. With No Inc. Doc.	External Document No.
22	201	Job Journal	External Document No.
23	207	Resource Journal	External Document No.
24	232	Apply Customer Entries	External Document No.
25	233	Apply Vendor Entries	External Document No.
26	253	Sales Journal	External Document No.
27	254	Purchase Journal	External Document No.
28	255	Cash Receipt Journal	External Document No.
29	256	Payment Journal	External Document No.
30	283	Recurring General Journal	External Document No.
31	289	Recurring Job Jnl.	External Document No.
32	315	VAT Entries	External Document No.
33	381	Apply Bank Acc. Ledger Entries	External Document No.
34	413	Applied Bank Acc. Ledger Entry	External Document No.
35	507	Blanket Sales Order	External Document No.
36	610	IC General Journal	External Document No.
37	741	VAT Report Subform	External Document No.
38	752	Standard Gen. Journal Subform	External Document No.
39	1020	Job G/L Journal	External Document No.
40	1234	Positive Pay Export Detail	External Document No.
41	1292	Payment Application	External Document No.
42	2583	Dim. Correct Ledger Entries	External Document No.
43	2584	Dim Correct Posted Ledg Entr	External Document No.
44	5159	Sales Order Archive	External Document No.
45	5161	Sales List Archive	External Document No.
46	5510	Production Journal	External Document No.
47	5628	Fixed Asset G/L Journal	External Document No.
48	5774	Warehouse Activity List	External Document No.
49	5793	Source Documents	External Document No.
50	5802	Value Entries	External Document No.
51	5803	Revaluation Journal	External Document No.
52	5807	Value Entries Preview	External Document No.
53	6561	Invt. Receipt	External Document No.
54	6563	Invt. Receipts	External Document No.
55	6564	Invt. Shipment	External Document No.
56	6566	Invt. Shipments	External Document No.
57	6567	Posted Invt. Receipt	External Document No.
58	6570	Posted Invt. Shipment	External Document No.
59	6620	Blanket Sales Order Archive	External Document No.
60	6622	Blanket Sales Order Archives	External Document No.
61	6627	Sales Return Order Archive	External Document No.
62	6629	Sales Return List Archive	External Document No.
63	6630	Sales Return Order	External Document No.
64	6660	Posted Return Receipt	External Document No.
65	6775	Invt. Document List	External Document No.
66	7335	Warehouse Shipment	External Document No.
67	7337	Posted Whse. Shipment	External Document No.
68	7375	Inventory Put-away	External Document No.
69	7377	Inventory Pick	External Document No.
70	7382	Inventory Movement	External Document No.
71	7384	Registered Invt. Movement	External Document No.
72	7390	Posted Invt. Put-away	External Document No.
73	7392	Posted Invt. Pick	External Document No.
74	9300	Sales Quotes	External Document No.
75	9301	Sales Invoice List	External Document No.
76	9302	Sales Credit Memos	External Document No.
77	9303	Blanket Sales Orders	External Document No.
78	9304	Sales Return Order List	External Document No.
79	9305	Sales Order List	External Document No.
80	9312	Warehouse Put-aways	External Document No.
81	9313	Warehouse Picks	External Document No.
82	9314	Warehouse Movements	External Document No.
83	9315	Inventory Put-aways	External Document No.
84	9316	Inventory Picks	External Document No.
85	9330	Inventory Movements	External Document No.
86	9348	Sales Quote Archives	External Document No.
87	9349	Sales Order Archives	External Document No.
88	99000773	Capacity Journal	External Document No.
89	99000778	Recurring Capacity Journal	External Document No.
90	99000823	Output Journal	External Document No.
91	99000827	Recurring Output Journal	External Document No.
92	99000846	Consumption Journal	External Document No.
93	99000850	Recurring Consumption Journal	External Document No.

Dynamics 365 BC Table ReferencePage Control Search